Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_LMT_FREE_SPACE

`DBA_LMT_FREE_SPACE` describes the free extents in all locally managed tablespaces in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TABLESPACE_ID` | `NUMBER` |  | Identifier number of the tablespace containing the extent
`FILE_ID` | `NUMBER` |  | File identifier number of the file containing the extent
`BLOCK_ID` | `NUMBER` |  | Starting block number of the extent
`BLOCKS` | `NUMBER` |  | Size of the extent (in Oracle blocks)